<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<?php

		
		function database($conn){
		if (!$conn) {
			echo "Koneksi Ke Database Gagal";
			exit;
		}
		}
		function prosesSql(){
		$conn = oci_connect("zipzip", "zipzip", "//localhost/XE");
		database($conn);
		$kd_pengiriman=$_GET['kd_pengiriman'];
		$q= "update data_konsumen_pengirim set status = 'Terkirim' where kd_pengiriman='$kd_pengiriman' ";
		$q2= "update data_konsumen_penerima set status = 'Terkirim' where kd_pengiriman='$kd_pengiriman' ";
		$q3= "update data_barang set status = 'Terkirim' where kd_pengiriman='$kd_pengiriman' ";
		$rs=oci_parse($conn,$q);
		oci_execute($rs);
		$rs2=oci_parse($conn,$q2);
		oci_execute($rs2);
		$rs3=oci_parse($conn,$q3);
		oci_execute($rs3);
		header("location:FormCetakBiayaDanKirimBarang.php");
		}
		prosesSql();
?>
<body>
</body>
</html>